Overview
What is MariaDB Platform?
MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database,…
MariaDB fast and reliable
Simplicity at your service
Using MariaDB with SaaS.
Great stability with no DDL operations
MariaDB: the little DB that could.
Positive Review for MariaDB
A Tiny Review of MariaDB
MariaDB Review
MariaDB economical high availability solution with great support
MariaDB Enterprise - Washing the taste of NoSQL out of my mouth!
Gets the job done without punishing you
Fast, reliable, economical database solution
MariaDB - great relational database solution
MariaDB is your go-to RDBMS solution if you need simplicity above all else
MariaDB is one of our go-to choices for …
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
What is MariaDB Platform?
MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and…
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
36 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is MariaDB Platform?
Other resources:
5 Key Steps for Selecting Your Ideal DBaaS
Guide to Open Source Database Selection: MariaDB vs. MySQL
Enterprise Database Comparison Guide – MariaDB vs. MS, IBM and Oracle
MariaDB Platform Features
- Supported: Cloud DBaaS: SkySQL
- Supported: Workloads: transactions, analytics and smart transactions (HTAP)
- Supported: Transactional scalability: distributed SQL
- Supported: Analytical scalability: columnar data with massively parallel processing
- Supported: Development: temporal tables, JSON documents and geospatial support
- Supported: High availability: automatic failover and transaction replay
- Supported: Disaster recovery: online backups and point-in-time restore
- Supported: Security: transparent data encryption and dynamic data masking
- Supported: Oracle Database compatiblity: data types, sequences and PL/SQL
MariaDB Platform Video
MariaDB Platform Competitors
MariaDB Platform Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Centos, Debian, RHEL, SLES, Ubuntu |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(76)Community Insights
- Business Problems Solved
- Pros
- Cons
MariaDB TX Cluster has been widely used in various industries and organizations, serving as a reliable and efficient solution for a wide range of applications. Users have migrated their operations from Oracle to MariaDB, finding it to be an efficient and reliable database for finance-related services. Additionally, MariaDB is being utilized in academic computing and research projects, providing a quick setup without the need for complex database administration. This has enabled institutions like Pomona College to focus more on their core objectives instead of spending valuable time and resources on managing databases.
Many applications and services heavily rely on MariaDB as their database server. For example, the Eduroam Authentication Service and Stoa, a social collaborative net and learning platform, use MariaDB to ensure smooth and reliable data storage. Furthermore, MariaDB is highly regarded as a drop-in replacement for MySQL, offering performance and stability upgrades without requiring changes to legacy applications. Its simplicity and practical maintenance-free nature make it suitable for low-maintenance systems.
Moreover, MariaDB is utilized in production environments where high availability is essential. The Enterprise 3-node cluster setup leverages improvements in InnoDB performance and SQL-mode features to provide robust database solutions. Whether it's content apps, configuration management, or contest apps, MariaDB serves as the main relational database solution for multiple applications requiring reliable storage.
In addition to these key use cases, organizations have successfully employed MariaDB for storing flattened data from various sources, addressing the need for working with disparate data. Users have also found value in using front-end UI tools like Heidi SQL to overcome command line limitations when leveraging the power of MariaDB. Moreover, MariaDB finds its application in monitoring solutions, open-source projects, and even as a backup option for replication scenarios.
The Aviation division of one company relies on MariaDB as its primary database server, supporting internal business tools that require reliable data storage. Customers have also reported great satisfaction with the product's ability to replicate data across multiple sites without the high costs associated with other database solutions. Moreover, reviewers have praised MariaDB for its performance and value, thanks to its flexible engines that allow for tuning based on the needs of different applications and data.
Overall, MariaDB has become a go-to choice for organizations of all sizes and industries. Its simplicity, reliability, and versatility have fueled its adoption for various use cases, making it a preferred database solution both internally and externally. From simple web applications to mission-critical systems, MariaDB has proven to be a valuable asset in managing and storing data. Another significant use case for MariaDB is its application in clustered setups with manual sharding. By utilizing multiple engines like Spider, Connect, Federated, MyISAM, Memory, InnoDB, and potentially ColumnStore, organizations can optimize data access and ensure efficient storage. This approach enables companies to handle large amounts of data while maintaining optimal performance and scalability.
Furthermore, MariaDB's licensing advantages and free software nature make it a popular choice for mission-critical applications. It serves as a reliable and cost-effective option for hosting various applications, including widely used platforms like WordPress and Magento. Many organizations have chosen MariaDB as their go-to relational database solution for both internal and third-party applications.
Beyond traditional database usage, MariaDB plays a crucial role in collecting and sending data to centralized servers while maintaining top performance. This decentralization capability allows organizations to distribute their data efficiently without sacrificing reliability or speed.
In terms of user experiences, customers have reported great satisfaction with MariaDB's performance and value. They appreciate the product's ability to provide replicated data across multiple sites without incurring high costs typically associated with other database solutions. Additionally, users have praised the fast and thorough support provided by the MariaDB team, ensuring smooth operations and quick issue resolution.
Overall, the versatility of MariaDB has positioned it as a dependable choice across various industries and applications. From serving as the primary relational database for critical systems to powering simple web applications quickly, MariaDB's simplicity, ease of use, reliability, and ability to handle diverse use cases make it an invaluable tool for businesses seeking robust database storage solutions.
High Availability: Many users have praised MariaDB TX Cluster for providing high availability, which is crucial for their business needs. This feature ensures that their databases are always accessible and minimizes downtime.
Performance Improvement: Several reviewers have mentioned the great advantage of using the proxy for MariaDB, MaxScale, as it significantly improves performance. Users appreciate the faster response times and enhanced efficiency they experience when using this feature.
Quick and Helpful Support: The prompt and helpful support provided by the MariaDB team has been highly appreciated by many users. They have stated that their questions were answered quickly and efficiently, making it easier for them to resolve any issues they encountered.
UI Lacking: Users have expressed dissatisfaction with the user interface of MariaDB, describing it as confusing and inefficient. They recommend incorporating UI tools similar to those offered by its competitors to enhance usability and streamline tasks. Some users feel that the current interface makes it difficult to perform tasks efficiently.
Replication Issues: Some users have encountered problems with replication in MariaDB, specifically related to table locks. They suggest that better troubleshooting tools be provided out of the box to address these issues effectively. This would help users resolve replication-related problems more easily.
Performance Impact: The addition of indexes to large tables and performing operations like altering the table has resulted in replication and storage issues, significantly impacting the overall performance of MariaDB. Users have reported experiencing slowdowns and delays due to these performance issues caused by certain database operations on large tables.
Attribute Ratings
Reviews
(1-11 of 11)Using MariaDB with SaaS.
- SQL - Is well known and supports most types of usage cases for a database.
- Open source - means there's lots of support and resources to develop on.
- Multi-platform - runs on any operating system and doesn't tie it down.
- Full text searches - slows startup to the extreme, leaks memory, can be buggy.
- Startup process needs to be streamlined and with more output. You shouldn't need to debug the system to find out what the startup process is doing.
- More consideration to using multiple databases. Most solutions seem to concentrate on single database products.
- MariaBackup is buggy and might not work on larger databases. Taking backups or restoring them takes manual work. Could really need some easy to use tools and less hand scripting shell scripts.
Positive Review for MariaDB
- Easy deployment.
- Ample amount of tools to be used.
- Documentation.
- Initial setup needs to be improved (determining correct configuration values).
- If replication fails, needs to be easier to recover.
- More functionality in the Community Server.
For any relational data, one of the easiest databases to use
Less appropriate
Big Data is lacking.
Performance, manageability of data
RDBMS at its best
- High performance and availability.
- Has an active open-source developer community.
- Robust transactional support.
- Availability of many storage engines.
- MariaDB is no longer completely compatible with MySQL, which makes migration a tedious process.
- Needs improvement in caching.
- It doesn't support full outer joins.
- Implementation of JSON datatype in MariaDB isn't ideal.
MariaDB Enterprise - Washing the taste of NoSQL out of my mouth!
- Replication - Works extremely well and has very reasonable latency.
- Monitoring - There is no shortage of tools for monitoring clusters.
- Reliability - Rock-solid product that appears to be quite resilient.
- I honestly can't think of anything I'd change.
MariaDB - great relational database solution
- It's easy to use for software development team members with knowledge of SQL.
- It's better than standard MySQL solutions, it's a little bit faster.
- It's also often required for some applications that we use for example CMS.
- While using with large data it's slowing.
It is noticeably slowing when working on tables with 10-20+ millions of rows. We had cases when we made operations, for example select or insert, on over 60 millions rows and some of them took a few seconds. It was crucial to use faster servers to achieve better latency.
MariaDB: good OLTP db
- Fast writes. Writes are fast, where it depends on the hardware.
- Reads are fast. Putting into memory is easy.
- Functions and procedures are easy to implement.
- Paritioning is nicely implemented.
- Bloating. Can't reduce the size of idx log file, especially when data is truncated from tables. Space is not reclaimed. Need to find way to "shrink" file.
- Writes are dependent on hardware. If hardware isn't great, writes will be effected. If that can still be solved through software.
- Flushing of cache data is not as fast as it should be. There can be cases of malformed data.
MariaDB vs. MySQL
- We are seeing more security releases than we did when we were running MySQL
- Very large queries complete more quickly on MariaDB than they do on MySQL
- Setting up Master-Master replication is more straightforward in MariaDB than it is in MySQL
- MariaDB doesn't yet have a Memcached interface
- CHECKSUM TABLE can give different results in MariaDB than in MySQL
Easy to store data with minimum CPU resources
- It gives better performance with a large amount of data.
- Easy to switch from SQL database.
- Help to take backups for integration and testers.
- Hard to implement relational queries.
- The graphical user interface should be more attractive.
- It does not show or allow to add a filter to the execution plan.
SQL database you can count on
- Easy to switch to it from MySQL. No client side re-configuration or re-programming is needed.
- Developed by open community.
- Widely supported in all environments and software.
- It's not guaranteed to be 100% compatible with MySQL (especially newer versions). However I've never encountered problems with this.
- Could have some UI tools incorporated into it like its competitors.
MariaDB implemetation first phase
- Gives us the flexibility to design data structures which can be joined to give data served by our APIs.
- Provides us options to use multiple storage engines based on the data being stored.
- Replication technology can definitely improve. Currently we face lot of issues with replication causing table locks.
- Provide better troubleshooting tools out of the box, for example a comprehensive GUI like SSMS for SQL Server.
- Alter table and add indexing is an overhead on large tables which causes replication and storage issues.
- Well suited for medium scale read and write systems
- Not suited for systems where write workloads are high and require multiple masters to support the volume
Maria DB Review
- Data Storage
- Data processing
- Data Retrieval
- Stronger help
- Better literature
- For small to meddium volumes of data there is nothing wrong with MySQL